ocr: - INDEX INDEX ONLY SORT INDICATOR PREFETCH MATERIALIZATION Any Any No Not L Incremental Yes No No L Hybrid RID list Sort RIDS Any Any Unique Not L Full Sort data - Temp table Yes No Unique Full RID list Sort RIDS Sort data Temp table Notes 1. "Any" means that it does not matter what value is in that position. 2. Somet times we: have combined method 3 EXPLAIN output lines, indicating a sort of the com- posite: table together with the line explaining the access to the: table. TABLE 2. SELECT DISTINCT.
